﻿CREATE TABLE [dbo].[SpecBoats_Tbl] (
    [SpecBoatID]         INT            IDENTITY (1, 1) NOT NULL,
    [BoatGenID]          INT            NULL,
    [BoatMake]           NVARCHAR (50)  NULL,
    [BoatModel]          NVARCHAR (50)  NULL,
    [BoatName]           NVARCHAR (255) NULL,
    [BoatType]           NVARCHAR (50)  NULL,
    [BoatManufacturerID] INT            NULL,
    [HullNumber]         INT            NULL,
    [Country]            NVARCHAR (50)  NULL,
    [SailNumber]         NVARCHAR (255) NULL,
    [BoatGenMsm]         NVARCHAR (255) NULL,
    [DateAmended]        NVARCHAR (255) NULL,
    [RecordCreated]      NVARCHAR (50)  NULL,
    [MeasurementID]      INT            NULL,
    [CustomerID]         INT            NULL
);

